When a Microsoft SQL Server backup is restored, it often includes the users that were associated with the database at the time of the backup. If the backup is used to restore on a new server, then there’s a good chance that the database users will be “disconnected” from the SQL Server users (if they exist at all). Fortunately, restoring access is simple.